SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE dbo.createTmpSSBtbl AS BEGIN
IF OBJECT_ID('dbo.tmpSSBDailyIncome', 'U') IS NOT NULL
  DROP TABLE [dbo].[tmpSSBDailyIncome]

CREATE TABLE [dbo].[tmpSSBDailyIncome](

	[Fund] [varchar](10) NOT NULL,
	[FundName] [varchar](100) NULL,
	[AccountNumber] [decimal](38, 10) NULL,
	[SubAccountNumber] [varchar](10) NULL,
	[AccountName] [varchar](100) NOT NULL,
	[Basis] [varchar](100) NULL,
	[ReportDateStartingBalance] [decimal](38, 10) NULL,
	[ReportDateCredits] [decimal](38, 10) NULL,
	[ReportDateDebits] [decimal](38, 10) NULL,
	[ReportDateNetAmount] [decimal](38, 10) NULL,
	[EndingLedgerBalance] [decimal](38, 10) NULL,
	[EndingLedgerBalanceDBCRInd] [varchar](10) NULL,
	[FinancialCurrencyName] [varchar](10) NULL,
	[FinancialStatementCurrency] [varchar](10) NULL,
	[LocalCurrencyCode] [varchar](10) NOT NULL,
	[LocalCurrencyName] [varchar](10) NULL,
	[BaseCurrencyCode] [varchar](10) NULL,
	[BaseCurrencyName] [varchar](10) NULL,
	[MultiCurrencyFlag] [varchar](10) NULL,
	[PeriodEndDate] [date] NOT NULL,
	[PeriodStartDate] [date] NULL,
	[PostingPeriod] [varchar](10) NULL,
	[RealMemoIndicator] [varchar](10) NULL,
)
END
GO
EXEC sp_addextendedproperty N'VirtualFolder', N'Live/CharlieWaterman', 'SCHEMA', N'dbo', 'PROCEDURE', N'createTmpSSBtbl', NULL, NULL
GO
